Overview
Brought to you by YData
Dataset statistics
| Number of variables | 24 |
|---|---|
| Number of observations | 5605 |
| Missing cells | 490 |
| Missing cells (%) | 0.4% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 1.0 MiB |
| Average record size in memory | 192.0 B |
Variable types
| DateTime | 3 |
|---|---|
| Text | 3 |
| Categorical | 10 |
| Numeric | 8 |
medicine_ended_or_recovered has constant value "1" | Constant |
age_category is highly overall correlated with age_of_patient and 2 other fields | High correlation |
age_of_patient is highly overall correlated with age_category and 2 other fields | High correlation |
base_cost is highly overall correlated with total_cost_of_medicine | High correlation |
code is highly overall correlated with age_category and 5 other fields | High correlation |
gender is highly overall correlated with code and 2 other fields | High correlation |
income is highly overall correlated with income_category | High correlation |
income_category is highly overall correlated with age_of_patient and 3 other fields | High correlation |
length_of_medication_in_days is highly overall correlated with medicine_dispenses | High correlation |
marital is highly overall correlated with age_category and 3 other fields | High correlation |
medicine_dispenses is highly overall correlated with length_of_medication_in_days | High correlation |
payer_id is highly overall correlated with income_category | High correlation |
race is highly overall correlated with gender | High correlation |
reason_code_for_medication is highly overall correlated with code and 1 other fields | High correlation |
reason_description_for_medication is highly overall correlated with code and 1 other fields | High correlation |
total_cost_of_medicine is highly overall correlated with base_cost | High correlation |
race is highly imbalanced (51.0%) | Imbalance |
ethnicity is highly imbalanced (73.8%) | Imbalance |
stop_time has 245 (4.4%) missing values | Missing |
length_of_medication_in_days has 245 (4.4%) missing values | Missing |
base_cost is highly skewed (γ1 = 43.181937) | Skewed |
payer_coverage is highly skewed (γ1 = 43.58464712) | Skewed |
total_cost_of_medicine is highly skewed (γ1 = 55.7427048) | Skewed |
length_of_medication_in_days is highly skewed (γ1 = 32.97911924) | Skewed |
payer_coverage has 2392 (42.7%) zeros | Zeros |
length_of_medication_in_days has 1081 (19.3%) zeros | Zeros |
Reproduction
| Analysis started | 2024-12-02 13:24:33.222765 |
|---|---|
| Analysis finished | 2024-12-02 13:24:43.175037 |
| Duration | 9.95 seconds |
| Software version | ydata-profiling vv4.12.0 |
| Download configuration | config.json |
Variables
start_time
Date
| Distinct | 2615 |
|---|---|
| Distinct (%) | 46.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 43.9 KiB |
| Minimum | 1959-01-01 05:47:15 |
|---|---|
| Maximum | 2024-11-01 02:26:29 |
Histogram with fixed size bins (bins=50)
stop_time
Date
Missing
| Distinct | 2478 |
|---|---|
| Distinct (%) | 46.2% |
| Missing | 245 |
| Missing (%) | 4.4% |
| Memory size | 43.9 KiB |
| Minimum | 1963-06-13 13:37:48 |
|---|---|
| Maximum | 2024-11-01 02:26:29 |
Histogram with fixed size bins (bins=50)
patient_id
Text
| Distinct | 105 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 43.9 KiB |
Length
| Max length | 36 |
|---|---|
| Median length | 36 |
| Mean length | 36 |
| Min length | 36 |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 30a6452c-4297-a1ac-977a-6a23237c7b46 |
|---|---|
| 2nd row | 30a6452c-4297-a1ac-977a-6a23237c7b46 |
| 3rd row | 34a4dcc4-35fb-6ad5-ab98-be285c586a4f |
| 4th row | 30a6452c-4297-a1ac-977a-6a23237c7b46 |
| 5th row | 34a4dcc4-35fb-6ad5-ab98-be285c586a4f |
| Value | Count | Frequency (%) |
| bad5a231-3709-952a-cf44-f8d6a52cc214 | 1303 | |
| d1622e8b-d26b-ec81-ffcb-ec4bf2af385b | 702 | |
| f3884e8a-8b36-1e93-66dd-e910dfab2ef5 | 616 | |
| d27273f0-f62d-7d7f-746d-4565f35cf176 | 605 | |
| cb1b46a1-9cb5-1187-ccc5-9fb7b98aa957 | 220 | 3.9% |
| 00732e11-5e4d-37b7-01f8-929a25536862 | 170 | 3.0% |
| 655baba7-47ed-22ac-2093-1196ebb44928 | 155 | 2.8% |
| 916b1ac8-56c8-ec1b-3b9a-721336a74912 | 131 | 2.3% |
| bd2a8021-2868-6dd2-c17f-bfd7c36fe247 | 122 | 2.2% |
| 14dc5e57-1b84-3305-c042-86c9fc7e4996 | 120 | 2.1% |
| Other values (95) | 1461 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 22420 | 11.1% |
| 2 | 15825 | 7.8% |
| f | 14156 | 7.0% |
| d | 12104 | 6.0% |
| c | 11846 | 5.9% |
| 6 | 11807 | 5.9% |
| a | 11651 | 5.8% |
| 5 | 11531 | 5.7% |
| b | 11530 | 5.7% |
| 1 | 11354 | 5.6% |
| Other values (7) | 67556 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 201780 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| - | 22420 | 11.1% |
| 2 | 15825 | 7.8% |
| f | 14156 | 7.0% |
| d | 12104 | 6.0% |
| c | 11846 | 5.9% |
| 6 | 11807 | 5.9% |
| a | 11651 | 5.8% |
| 5 | 11531 | 5.7% |
| b | 11530 | 5.7% |
| 1 | 11354 | 5.6% |
| Other values (7) | 67556 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 201780 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| - | 22420 | 11.1% |
| 2 | 15825 | 7.8% |
| f | 14156 | 7.0% |
| d | 12104 | 6.0% |
| c | 11846 | 5.9% |
| 6 | 11807 | 5.9% |
| a | 11651 | 5.8% |
| 5 | 11531 | 5.7% |
| b | 11530 | 5.7% |
| 1 | 11354 | 5.6% |
| Other values (7) | 67556 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 201780 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| - | 22420 | 11.1% |
| 2 | 15825 | 7.8% |
| f | 14156 | 7.0% |
| d | 12104 | 6.0% |
| c | 11846 | 5.9% |
| 6 | 11807 | 5.9% |
| a | 11651 | 5.8% |
| 5 | 11531 | 5.7% |
| b | 11530 | 5.7% |
| 1 | 11354 | 5.6% |
| Other values (7) | 67556 |
payer_id
Categorical
High correlation
| Distinct | 10 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 43.9 KiB |
| a735bf55-83e9-331a-899d-a82a60b9f60c | |
|---|---|
| e03e23c9-4df1-3eb6-a62d-f70f02301496 | |
| df166300-5a78-3502-a46a-832842197811 | |
| b046940f-1664-3047-bca7-dfa76be352a4 | 256 |
| 734afbd6-4794-363b-9bc0-6a3981533ed5 | 225 |
| Other values (5) |
Length
| Max length | 36 |
|---|---|
| Median length | 36 |
| Mean length | 36 |
| Min length | 36 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | d31fccc3-1767-390d-966a-22a5156f4219 |
|---|---|
| 2nd row | d31fccc3-1767-390d-966a-22a5156f4219 |
| 3rd row | e03e23c9-4df1-3eb6-a62d-f70f02301496 |
| 4th row | d31fccc3-1767-390d-966a-22a5156f4219 |
| 5th row | 8fa6c185-e44e-3e34-8bd8-39be8694f4ce |
Common Values
| Value | Count | Frequency (%) |
| a735bf55-83e9-331a-899d-a82a60b9f60c | 2881 | |
| e03e23c9-4df1-3eb6-a62d-f70f02301496 | 1244 | |
| df166300-5a78-3502-a46a-832842197811 | 486 | 8.7% |
| b046940f-1664-3047-bca7-dfa76be352a4 | 256 | 4.6% |
| 734afbd6-4794-363b-9bc0-6a3981533ed5 | 225 | 4.0% |
| 0133f751-9229-3cfd-815f-b6d4979bdd6a | 174 | 3.1% |
| 26aab0cd-6aba-3e1b-ac5b-05c8867e762c | 156 | 2.8% |
| d31fccc3-1767-390d-966a-22a5156f4219 | 109 | 1.9% |
| 8fa6c185-e44e-3e34-8bd8-39be8694f4ce | 47 | 0.8% |
| d18ef2e6-ef40-324c-be54-34a5ee865625 | 27 | 0.5% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| a735bf55-83e9-331a-899d-a82a60b9f60c | 2881 | |
| e03e23c9-4df1-3eb6-a62d-f70f02301496 | 1244 | |
| df166300-5a78-3502-a46a-832842197811 | 486 | 8.7% |
| b046940f-1664-3047-bca7-dfa76be352a4 | 256 | 4.6% |
| 734afbd6-4794-363b-9bc0-6a3981533ed5 | 225 | 4.0% |
| 0133f751-9229-3cfd-815f-b6d4979bdd6a | 174 | 3.1% |
| 26aab0cd-6aba-3e1b-ac5b-05c8867e762c | 156 | 2.8% |
| d31fccc3-1767-390d-966a-22a5156f4219 | 109 | 1.9% |
| 8fa6c185-e44e-3e34-8bd8-39be8694f4ce | 47 | 0.8% |
| d18ef2e6-ef40-324c-be54-34a5ee865625 | 27 | 0.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 22420 | |
| 3 | 21020 | 10.4% |
| a | 16690 | 8.3% |
| 9 | 16546 | 8.2% |
| 6 | 14234 | 7.1% |
| 0 | 13811 | 6.8% |
| f | 11605 | 5.8% |
| 8 | 11587 | 5.7% |
| 5 | 11354 | 5.6% |
| b | 9542 | 4.7% |
| Other values (7) | 52971 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 201780 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| - | 22420 | |
| 3 | 21020 | 10.4% |
| a | 16690 | 8.3% |
| 9 | 16546 | 8.2% |
| 6 | 14234 | 7.1% |
| 0 | 13811 | 6.8% |
| f | 11605 | 5.8% |
| 8 | 11587 | 5.7% |
| 5 | 11354 | 5.6% |
| b | 9542 | 4.7% |
| Other values (7) | 52971 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 201780 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| - | 22420 | |
| 3 | 21020 | 10.4% |
| a | 16690 | 8.3% |
| 9 | 16546 | 8.2% |
| 6 | 14234 | 7.1% |
| 0 | 13811 | 6.8% |
| f | 11605 | 5.8% |
| 8 | 11587 | 5.7% |
| 5 | 11354 | 5.6% |
| b | 9542 | 4.7% |
| Other values (7) | 52971 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 201780 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| - | 22420 | |
| 3 | 21020 | 10.4% |
| a | 16690 | 8.3% |
| 9 | 16546 | 8.2% |
| 6 | 14234 | 7.1% |
| 0 | 13811 | 6.8% |
| f | 11605 | 5.8% |
| 8 | 11587 | 5.7% |
| 5 | 11354 | 5.6% |
| b | 9542 | 4.7% |
| Other values (7) | 52971 |
encounter_id
Text
| Distinct | 2578 |
|---|---|
| Distinct (%) | 46.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 43.9 KiB |
Length
| Max length | 36 |
|---|---|
| Median length | 36 |
| Mean length | 36 |
| Min length | 36 |
Unique
| Unique | 1597 ? |
|---|---|
| Unique (%) | 28.5% |
Sample
| 1st row | 953c5138-ce17-4084-3432-1ac23f184528 |
|---|---|
| 2nd row | 953c5138-ce17-4084-3432-1ac23f184528 |
| 3rd row | d1cea2e5-1735-089f-c72f-22ad16976663 |
| 4th row | 794baa15-fe5e-c061-e188-ad59022aeea5 |
| 5th row | 8a84efee-6fd7-f5b3-8816-9a1c60e720be |
| Value | Count | Frequency (%) |
| d6a83835-7bbf-5aed-ceb1-1039fa5417e3 | 28 | 0.5% |
| 275edbad-1214-e1d5-1bbf-5fc04d2e68b0 | 9 | 0.2% |
| bb908ad6-5d04-34c1-818b-cb7221f51f46 | 9 | 0.2% |
| ead70e1d-2b64-fc7d-d047-3c5d811c993b | 9 | 0.2% |
| 631b2013-81d5-f250-6d06-dabe6fc95630 | 9 | 0.2% |
| d43fa1a9-7705-ab8b-374a-ddc44221864b | 9 | 0.2% |
| ddc13a1d-d1c6-308b-f637-9f7915381f0d | 9 | 0.2% |
| 5ed28b7a-d1e9-8d89-4ea7-17dc975f95ee | 9 | 0.2% |
| e1dc8109-e21e-cac9-abb8-cc4979473ca5 | 9 | 0.2% |
| ccf0b32b-e70a-0690-56a6-027189b0b7c5 | 9 | 0.2% |
| Other values (2568) | 5496 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 22420 | 11.1% |
| b | 11655 | 5.8% |
| a | 11433 | 5.7% |
| 7 | 11428 | 5.7% |
| 8 | 11384 | 5.6% |
| c | 11375 | 5.6% |
| 6 | 11268 | 5.6% |
| 1 | 11217 | 5.6% |
| 0 | 11213 | 5.6% |
| d | 11199 | 5.6% |
| Other values (7) | 77188 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 201780 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| - | 22420 | 11.1% |
| b | 11655 | 5.8% |
| a | 11433 | 5.7% |
| 7 | 11428 | 5.7% |
| 8 | 11384 | 5.6% |
| c | 11375 | 5.6% |
| 6 | 11268 | 5.6% |
| 1 | 11217 | 5.6% |
| 0 | 11213 | 5.6% |
| d | 11199 | 5.6% |
| Other values (7) | 77188 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 201780 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| - | 22420 | 11.1% |
| b | 11655 | 5.8% |
| a | 11433 | 5.7% |
| 7 | 11428 | 5.7% |
| 8 | 11384 | 5.6% |
| c | 11375 | 5.6% |
| 6 | 11268 | 5.6% |
| 1 | 11217 | 5.6% |
| 0 | 11213 | 5.6% |
| d | 11199 | 5.6% |
| Other values (7) | 77188 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 201780 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| - | 22420 | 11.1% |
| b | 11655 | 5.8% |
| a | 11433 | 5.7% |
| 7 | 11428 | 5.7% |
| 8 | 11384 | 5.6% |
| c | 11375 | 5.6% |
| 6 | 11268 | 5.6% |
| 1 | 11217 | 5.6% |
| 0 | 11213 | 5.6% |
| d | 11199 | 5.6% |
| Other values (7) | 77188 |
code
Real number (ℝ)
High correlation
| Distinct | 116 |
|---|---|
| Distinct (%) | 2.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 518218.68 |
| Minimum | 106258 |
|---|---|
| Maximum | 2119714 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 43.9 KiB |
Quantile statistics
| Minimum | 106258 |
|---|---|
| 5-th percentile | 106892 |
| Q1 | 209387 |
| median | 310798 |
| Q3 | 834061 |
| 95-th percentile | 1535362 |
| Maximum | 2119714 |
| Range | 2013456 |
| Interquartile range (IQR) | 624674 |
Descriptive statistics
| Standard deviation | 450113.87 |
|---|---|
| Coefficient of variation (CV) | 0.86857901 |
| Kurtosis | 1.0112971 |
| Mean | 518218.68 |
| Median Absolute Deviation (MAD) | 104875 |
| Skewness | 1.4383095 |
| Sum | 2.9046157 × 109 |
| Variance | 2.0260249 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 314076 | 747 | |
| 205923 | 645 | 11.5% |
| 106892 | 499 | 8.9% |
| 310798 | 488 | 8.7% |
| 308136 | 448 | 8.0% |
| 1535362 | 311 | 5.5% |
| 209387 | 301 | 5.4% |
| 1664463 | 181 | 3.2% |
| 245314 | 174 | 3.1% |
| 835603 | 154 | 2.7% |
| Other values (106) | 1657 |
| Value | Count | Frequency (%) |
| 106258 | 2 | < 0.1% |
| 106892 | 499 | |
| 108515 | 37 | 0.7% |
| 197319 | 1 | < 0.1% |
| 197454 | 5 | 0.1% |
| 197511 | 2 | < 0.1% |
| 197591 | 2 | < 0.1% |
| 198014 | 2 | < 0.1% |
| 198240 | 2 | < 0.1% |
| 198335 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 2119714 | 3 | 0.1% |
| 2001499 | 4 | 0.1% |
| 1873983 | 1 | < 0.1% |
| 1870230 | 10 | |
| 1860491 | 7 | |
| 1860480 | 2 | < 0.1% |
| 1860154 | 16 | |
| 1856546 | 1 | < 0.1% |
| 1808217 | 1 | < 0.1% |
| 1807510 | 1 | < 0.1% |
| Distinct | 121 |
|---|---|
| Distinct (%) | 2.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 43.9 KiB |
Length
| Max length | 113 |
|---|---|
| Median length | 92 |
| Mean length | 47.213024 |
| Min length | 15 |
Unique
| Unique | 29 ? |
|---|---|
| Unique (%) | 0.5% |
Sample
| 1st row | Acetaminophen 325 MG / HYDROcodone Bitartrate 7.5 MG Oral Tablet |
|---|---|
| 2nd row | Ibuprofen 200 MG Oral Tablet |
| 3rd row | ferrous sulfate 325 MG Oral Tablet |
| 4th row | Acetaminophen 325 MG Oral Tablet |
| 5th row | sodium fluoride 0.0272 MG/MG Oral Gel |
| Value | Count | Frequency (%) |
| mg | 3532 | 8.8% |
| oral | 3512 | 8.7% |
| tablet | 3185 | 7.9% |
| unt/ml | 1647 | 4.1% |
| insulin | 998 | 2.5% |
| human | 998 | 2.5% |
| 10 | 944 | 2.3% |
| 1 | 903 | 2.2% |
| 848 | 2.1% | |
| lisinopril | 747 | 1.9% |
| Other values (230) | 22946 |
Most occurring characters
| Value | Count | Frequency (%) |
| 36163 | 13.7% | |
| e | 17173 | 6.5% |
| l | 16616 | 6.3% |
| a | 15195 | 5.7% |
| n | 14811 | 5.6% |
| i | 12985 | 4.9% |
| o | 11983 | 4.5% |
| r | 10137 | 3.8% |
| t | 9691 | 3.7% |
| M | 8267 | 3.1% |
| Other values (56) | 111608 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 264629 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 36163 | 13.7% | |
| e | 17173 | 6.5% |
| l | 16616 | 6.3% |
| a | 15195 | 5.7% |
| n | 14811 | 5.6% |
| i | 12985 | 4.9% |
| o | 11983 | 4.5% |
| r | 10137 | 3.8% |
| t | 9691 | 3.7% |
| M | 8267 | 3.1% |
| Other values (56) | 111608 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 264629 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 36163 | 13.7% | |
| e | 17173 | 6.5% |
| l | 16616 | 6.3% |
| a | 15195 | 5.7% |
| n | 14811 | 5.6% |
| i | 12985 | 4.9% |
| o | 11983 | 4.5% |
| r | 10137 | 3.8% |
| t | 9691 | 3.7% |
| M | 8267 | 3.1% |
| Other values (56) | 111608 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 264629 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 36163 | 13.7% | |
| e | 17173 | 6.5% |
| l | 16616 | 6.3% |
| a | 15195 | 5.7% |
| n | 14811 | 5.6% |
| i | 12985 | 4.9% |
| o | 11983 | 4.5% |
| r | 10137 | 3.8% |
| t | 9691 | 3.7% |
| M | 8267 | 3.1% |
| Other values (56) | 111608 |
base_cost
Real number (ℝ)
High correlation Skewed
| Distinct | 845 |
|---|---|
| Distinct (%) | 15.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 143.60708 |
| Minimum | 0.01 |
|---|---|
| Maximum | 103958.4 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 43.9 KiB |
Quantile statistics
| Minimum | 0.01 |
|---|---|
| 5-th percentile | 0.45 |
| Q1 | 0.91 |
| median | 40.79 |
| Q3 | 129.94 |
| 95-th percentile | 296.37 |
| Maximum | 103958.4 |
| Range | 103958.39 |
| Interquartile range (IQR) | 129.03 |
Descriptive statistics
| Standard deviation | 2316.235 |
|---|---|
| Coefficient of variation (CV) | 16.128975 |
| Kurtosis | 1875.4342 |
| Mean | 143.60708 |
| Median Absolute Deviation (MAD) | 40.34 |
| Skewness | 43.181937 |
| Sum | 804917.69 |
| Variance | 5364944.5 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 129.94 | 1880 | |
| 0.91 | 1108 | |
| 29.21 | 409 | 7.3% |
| 0.45 | 318 | 5.7% |
| 30.67 | 220 | 3.9% |
| 126.89 | 185 | 3.3% |
| 1.37 | 97 | 1.7% |
| 507.86 | 75 | 1.3% |
| 45.86 | 47 | 0.8% |
| 6.87 | 44 | 0.8% |
| Other values (835) | 1222 |
| Value | Count | Frequency (%) |
| 0.01 | 8 | |
| 0.02 | 1 | < 0.1% |
| 0.03 | 5 | |
| 0.09 | 1 | < 0.1% |
| 0.11 | 1 | < 0.1% |
| 0.13 | 1 | < 0.1% |
| 0.15 | 5 | |
| 0.18 | 1 | < 0.1% |
| 0.22 | 1 | < 0.1% |
| 0.27 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 103958.4 | 2 | |
| 91728 | 1 | |
| 4517.84 | 1 | |
| 2421.72 | 1 | |
| 1886.37 | 1 | |
| 1507.01 | 1 | |
| 1347.43 | 1 | |
| 994.39 | 1 | |
| 944.05 | 1 | |
| 917.28 | 2 |
payer_coverage
Real number (ℝ)
Skewed Zeros
| Distinct | 553 |
|---|---|
| Distinct (%) | 9.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 89.287058 |
| Minimum | 0 |
|---|---|
| Maximum | 91678 |
| Zeros | 2392 |
| Zeros (%) | 42.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 43.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.73 |
| Q3 | 101.51 |
| 95-th percentile | 167.172 |
| Maximum | 91678 |
| Range | 91678 |
| Interquartile range (IQR) | 101.51 |
Descriptive statistics
| Standard deviation | 1919.087 |
|---|---|
| Coefficient of variation (CV) | 21.493451 |
| Kurtosis | 1918.6258 |
| Mean | 89.287058 |
| Median Absolute Deviation (MAD) | 0.73 |
| Skewness | 43.584647 |
| Sum | 500453.96 |
| Variance | 3682895.1 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 2392 | |
| 103.95 | 896 | 16.0% |
| 0.73 | 531 | 9.5% |
| 23.37 | 305 | 5.4% |
| 24.54 | 163 | 2.9% |
| 0.36 | 127 | 2.3% |
| 101.51 | 119 | 2.1% |
| 79.94 | 99 | 1.8% |
| 0.91 | 60 | 1.1% |
| 129.94 | 58 | 1.0% |
| Other values (543) | 855 | 15.3% |
| Value | Count | Frequency (%) |
| 0 | 2392 | |
| 0.07 | 1 | < 0.1% |
| 0.09 | 1 | < 0.1% |
| 0.1 | 2 | < 0.1% |
| 0.14 | 1 | < 0.1% |
| 0.18 | 2 | < 0.1% |
| 0.24 | 8 | 0.1% |
| 0.25 | 1 | < 0.1% |
| 0.31 | 1 | < 0.1% |
| 0.32 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 91678 | 1 | |
| 83166.72 | 1 | |
| 72770.88 | 1 | |
| 3614.27 | 1 | |
| 1322.7 | 1 | |
| 1312.43 | 1 | |
| 828.12 | 1 | |
| 764.4 | 2 | |
| 733.82 | 2 | |
| 714.4 | 1 |
medicine_dispenses
Real number (ℝ)
High correlation
| Distinct | 62 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.2453167 |
| Minimum | 1 |
|---|---|
| Maximum | 801 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 43.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 3 |
| 95-th percentile | 12 |
| Maximum | 801 |
| Range | 800 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 40.035579 |
|---|---|
| Coefficient of variation (CV) | 6.4104962 |
| Kurtosis | 174.92002 |
| Mean | 6.2453167 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 12.26836 |
| Sum | 35005 |
| Variance | 1602.8476 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 3894 | |
| 3 | 942 | 16.8% |
| 4 | 272 | 4.9% |
| 12 | 217 | 3.9% |
| 2 | 116 | 2.1% |
| 10 | 19 | 0.3% |
| 7 | 12 | 0.2% |
| 6 | 12 | 0.2% |
| 9 | 8 | 0.1% |
| 5 | 6 | 0.1% |
| Other values (52) | 107 | 1.9% |
| Value | Count | Frequency (%) |
| 1 | 3894 | |
| 2 | 116 | 2.1% |
| 3 | 942 | 16.8% |
| 4 | 272 | 4.9% |
| 5 | 6 | 0.1% |
| 6 | 12 | 0.2% |
| 7 | 12 | 0.2% |
| 8 | 6 | 0.1% |
| 9 | 8 | 0.1% |
| 10 | 19 | 0.3% |
| Value | Count | Frequency (%) |
| 801 | 1 | |
| 751 | 1 | |
| 730 | 1 | |
| 718 | 1 | |
| 694 | 1 | |
| 638 | 1 | |
| 631 | 1 | |
| 553 | 2 | |
| 525 | 1 | |
| 496 | 1 |
total_cost_of_medicine
Real number (ℝ)
High correlation Skewed
| Distinct | 977 |
|---|---|
| Distinct (%) | 17.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7807.0456 |
| Minimum | 0.01 |
|---|---|
| Maximum | 23182723 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 43.9 KiB |
Quantile statistics
| Minimum | 0.01 |
|---|---|
| 5-th percentile | 0.58 |
| Q1 | 1.37 |
| median | 67.73 |
| Q3 | 233.13 |
| 95-th percentile | 733.638 |
| Maximum | 23182723 |
| Range | 23182723 |
| Interquartile range (IQR) | 231.76 |
Descriptive statistics
| Standard deviation | 372640.65 |
|---|---|
| Coefficient of variation (CV) | 47.731327 |
| Kurtosis | 3201.5132 |
| Mean | 7807.0456 |
| Median Absolute Deviation (MAD) | 66.81 |
| Skewness | 55.742705 |
| Sum | 43758491 |
| Variance | 1.3886106 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 129.94 | 1012 | |
| 0.91 | 907 | |
| 389.82 | 835 | |
| 29.21 | 409 | 7.3% |
| 0.45 | 229 | 4.1% |
| 30.67 | 220 | 3.9% |
| 126.89 | 141 | 2.5% |
| 3.64 | 135 | 2.4% |
| 1.37 | 77 | 1.4% |
| 507.86 | 61 | 1.1% |
| Other values (967) | 1579 |
| Value | Count | Frequency (%) |
| 0.01 | 8 | 0.1% |
| 0.02 | 1 | < 0.1% |
| 0.03 | 5 | 0.1% |
| 0.09 | 1 | < 0.1% |
| 0.11 | 1 | < 0.1% |
| 0.13 | 1 | < 0.1% |
| 0.15 | 1 | < 0.1% |
| 0.18 | 1 | < 0.1% |
| 0.22 | 1 | < 0.1% |
| 0.45 | 229 |
| Value | Count | Frequency (%) |
| 23182723.2 | 1 | |
| 15489801.6 | 1 | |
| 967454.74 | 1 | |
| 290361.88 | 1 | |
| 101092.96 | 1 | |
| 96965.9 | 1 | |
| 91728 | 1 | |
| 89604.9 | 1 | |
| 87025.98 | 1 | |
| 82113.84 | 1 |
reason_code_for_medication
Categorical
High correlation
| Distinct | 37 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 43.9 KiB |
| 59621000.0 | |
|---|---|
| Unknown | |
| 271737000.0 | |
| 233678006.0 | |
| 44054006.0 | |
| Other values (32) |
Length
| Max length | 11 |
|---|---|
| Median length | 10 |
| Mean length | 9.6754683 |
| Min length | 7 |
Unique
| Unique | 10 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | Unknown |
|---|---|
| 2nd row | Unknown |
| 3rd row | Unknown |
| 4th row | Unknown |
| 5th row | 66383009.0 |
Common Values
| Value | Count | Frequency (%) |
| 59621000.0 | 1683 | |
| Unknown | 1271 | |
| 271737000.0 | 645 | 11.5% |
| 233678006.0 | 628 | 11.2% |
| 44054006.0 | 267 | 4.8% |
| 714628002.0 | 245 | 4.4% |
| 161665007.0 | 214 | 3.8% |
| 103697008.0 | 161 | 2.9% |
| 66383009.0 | 148 | 2.6% |
| 64859006.0 | 74 | 1.3% |
| Other values (27) | 269 | 4.8% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 59621000.0 | 1683 | |
| unknown | 1271 | |
| 271737000.0 | 645 | 11.5% |
| 233678006.0 | 628 | 11.2% |
| 44054006.0 | 267 | 4.8% |
| 714628002.0 | 245 | 4.4% |
| 161665007.0 | 214 | 3.8% |
| 103697008.0 | 161 | 2.9% |
| 66383009.0 | 148 | 2.6% |
| 64859006.0 | 74 | 1.3% |
| Other values (27) | 269 | 4.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 15944 | |
| 6 | 4781 | 8.8% |
| . | 4334 | 8.0% |
| n | 3813 | 7.0% |
| 2 | 3675 | 6.8% |
| 1 | 3307 | 6.1% |
| 7 | 3294 | 6.1% |
| 3 | 2498 | 4.6% |
| 5 | 2451 | 4.5% |
| 9 | 2211 | 4.1% |
| Other values (6) | 7923 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 54231 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 15944 | |
| 6 | 4781 | 8.8% |
| . | 4334 | 8.0% |
| n | 3813 | 7.0% |
| 2 | 3675 | 6.8% |
| 1 | 3307 | 6.1% |
| 7 | 3294 | 6.1% |
| 3 | 2498 | 4.6% |
| 5 | 2451 | 4.5% |
| 9 | 2211 | 4.1% |
| Other values (6) | 7923 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 54231 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 15944 | |
| 6 | 4781 | 8.8% |
| . | 4334 | 8.0% |
| n | 3813 | 7.0% |
| 2 | 3675 | 6.8% |
| 1 | 3307 | 6.1% |
| 7 | 3294 | 6.1% |
| 3 | 2498 | 4.6% |
| 5 | 2451 | 4.5% |
| 9 | 2211 | 4.1% |
| Other values (6) | 7923 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 54231 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 15944 | |
| 6 | 4781 | 8.8% |
| . | 4334 | 8.0% |
| n | 3813 | 7.0% |
| 2 | 3675 | 6.8% |
| 1 | 3307 | 6.1% |
| 7 | 3294 | 6.1% |
| 3 | 2498 | 4.6% |
| 5 | 2451 | 4.5% |
| 9 | 2211 | 4.1% |
| Other values (6) | 7923 |
reason_description_for_medication
Categorical
High correlation
| Distinct | 37 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 43.9 KiB |
| Essential hypertension (disorder) | |
|---|---|
| Unknown | |
| Anemia (disorder) | |
| Childhood asthma (disorder) | |
| Diabetes mellitus type 2 (disorder) | |
| Other values (32) |
Length
| Max length | 67 |
|---|---|
| Median length | 59 |
| Mean length | 24.196967 |
| Min length | 7 |
Unique
| Unique | 10 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | Unknown |
|---|---|
| 2nd row | Unknown |
| 3rd row | Unknown |
| 4th row | Unknown |
| 5th row | Gingivitis (disorder) |
Common Values
| Value | Count | Frequency (%) |
| Essential hypertension (disorder) | 1683 | |
| Unknown | 1271 | |
| Anemia (disorder) | 645 | 11.5% |
| Childhood asthma (disorder) | 628 | 11.2% |
| Diabetes mellitus type 2 (disorder) | 267 | 4.8% |
| Prediabetes (finding) | 245 | 4.4% |
| History of renal transplant (situation) | 214 | 3.8% |
| Patient referral for dental care (procedure) | 161 | 2.9% |
| Gingivitis (disorder) | 148 | 2.6% |
| Osteoporosis (disorder) | 74 | 1.3% |
| Other values (27) | 269 | 4.8% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| disorder | 3717 | |
| essential | 1683 | |
| hypertension | 1683 | |
| unknown | 1271 | 8.6% |
| anemia | 645 | 4.4% |
| childhood | 628 | 4.3% |
| asthma | 628 | 4.3% |
| mellitus | 267 | 1.8% |
| diabetes | 267 | 1.8% |
| type | 267 | 1.8% |
| Other values (74) | 3646 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 13079 | 9.6% |
| i | 11722 | 8.6% |
| n | 11589 | 8.5% |
| r | 11586 | 8.5% |
| s | 11514 | 8.5% |
| d | 9584 | 7.1% |
| o | 9470 | 7.0% |
| 9100 | 6.7% | |
| t | 7301 | 5.4% |
| a | 5901 | 4.4% |
| Other values (35) | 34778 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 135624 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 13079 | 9.6% |
| i | 11722 | 8.6% |
| n | 11589 | 8.5% |
| r | 11586 | 8.5% |
| s | 11514 | 8.5% |
| d | 9584 | 7.1% |
| o | 9470 | 7.0% |
| 9100 | 6.7% | |
| t | 7301 | 5.4% |
| a | 5901 | 4.4% |
| Other values (35) | 34778 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 135624 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 13079 | 9.6% |
| i | 11722 | 8.6% |
| n | 11589 | 8.5% |
| r | 11586 | 8.5% |
| s | 11514 | 8.5% |
| d | 9584 | 7.1% |
| o | 9470 | 7.0% |
| 9100 | 6.7% | |
| t | 7301 | 5.4% |
| a | 5901 | 4.4% |
| Other values (35) | 34778 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 135624 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 13079 | 9.6% |
| i | 11722 | 8.6% |
| n | 11589 | 8.5% |
| r | 11586 | 8.5% |
| s | 11514 | 8.5% |
| d | 9584 | 7.1% |
| o | 9470 | 7.0% |
| 9100 | 6.7% | |
| t | 7301 | 5.4% |
| a | 5901 | 4.4% |
| Other values (35) | 34778 |
length_of_medication_in_days
Real number (ℝ)
High correlation Missing Skewed Zeros
| Distinct | 134 |
|---|---|
| Distinct (%) | 2.5% |
| Missing | 245 |
| Missing (%) | 4.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.20809037 |
| Minimum | 0 |
|---|---|
| Maximum | 38.471233 |
| Zeros | 1081 |
| Zeros (%) | 19.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 43.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.019178082 |
| median | 0.057534247 |
| Q3 | 0.13424658 |
| 95-th percentile | 1.0164384 |
| Maximum | 38.471233 |
| Range | 38.471233 |
| Interquartile range (IQR) | 0.11506849 |
Descriptive statistics
| Standard deviation | 0.76832683 |
|---|---|
| Coefficient of variation (CV) | 3.6922748 |
| Kurtosis | 1441.3973 |
| Mean | 0.20809037 |
| Median Absolute Deviation (MAD) | 0.038356164 |
| Skewness | 32.979119 |
| Sum | 1115.3644 |
| Variance | 0.59032612 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.01917808219 | 1137 | |
| 0 | 1081 | |
| 0.07671232877 | 712 | |
| 1.016438356 | 452 | 8.1% |
| 0.05753424658 | 359 | 6.4% |
| 0.09589041096 | 269 | 4.8% |
| 0.03835616438 | 151 | 2.7% |
| 0.1534246575 | 143 | 2.6% |
| 0.1150684932 | 116 | 2.1% |
| 0.1726027397 | 99 | 1.8% |
| Other values (124) | 841 | |
| (Missing) | 245 | 4.4% |
| Value | Count | Frequency (%) |
| 0 | 1081 | |
| 0.002739726027 | 10 | 0.2% |
| 0.01917808219 | 1137 | |
| 0.02191780822 | 10 | 0.2% |
| 0.02465753425 | 2 | < 0.1% |
| 0.02739726027 | 6 | 0.1% |
| 0.0301369863 | 9 | 0.2% |
| 0.03287671233 | 11 | 0.2% |
| 0.03561643836 | 7 | 0.1% |
| 0.03835616438 | 151 | 2.7% |
| Value | Count | Frequency (%) |
| 38.47123288 | 1 | |
| 26.40821918 | 1 | |
| 15.07671233 | 1 | |
| 13.26849315 | 1 | |
| 6.060273973 | 1 | |
| 4.161643836 | 1 | |
| 3.032876712 | 1 | |
| 2.032876712 | 1 | |
| 1.120547945 | 1 | |
| 1.068493151 | 1 |
medicine_ended_or_recovered
Categorical
Constant
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 43.9 KiB |
| 1 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 5605 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 5605 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 5605 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 5605 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 5605 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 5605 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 5605 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 5605 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 5605 |
birthdate
Date
| Distinct | 99 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 43.9 KiB |
| Minimum | 1914-03-03 00:00:00 |
|---|---|
| Maximum | 2023-03-01 00:00:00 |
Histogram with fixed size bins (bins=50)
marital
Categorical
High correlation
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 43.9 KiB |
| M | |
|---|---|
| D | |
| Unknown | |
| S | 333 |
| W | 236 |
Length
| Max length | 7 |
|---|---|
| Median length | 1 |
| Mean length | 1.4271186 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | M |
|---|---|
| 2nd row | M |
| 3rd row | D |
| 4th row | M |
| 5th row | D |
Common Values
| Value | Count | Frequency (%) |
| M | 3636 | |
| D | 1001 | 17.9% |
| Unknown | 399 | 7.1% |
| S | 333 | 5.9% |
| W | 236 | 4.2% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| m | 3636 | |
| d | 1001 | 17.9% |
| unknown | 399 | 7.1% |
| s | 333 | 5.9% |
| w | 236 | 4.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| M | 3636 | |
| n | 1197 | 15.0% |
| D | 1001 | 12.5% |
| U | 399 | 5.0% |
| k | 399 | 5.0% |
| o | 399 | 5.0% |
| w | 399 | 5.0% |
| S | 333 | 4.2% |
| W | 236 | 3.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7999 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| M | 3636 | |
| n | 1197 | 15.0% |
| D | 1001 | 12.5% |
| U | 399 | 5.0% |
| k | 399 | 5.0% |
| o | 399 | 5.0% |
| w | 399 | 5.0% |
| S | 333 | 4.2% |
| W | 236 | 3.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7999 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| M | 3636 | |
| n | 1197 | 15.0% |
| D | 1001 | 12.5% |
| U | 399 | 5.0% |
| k | 399 | 5.0% |
| o | 399 | 5.0% |
| w | 399 | 5.0% |
| S | 333 | 4.2% |
| W | 236 | 3.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7999 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| M | 3636 | |
| n | 1197 | 15.0% |
| D | 1001 | 12.5% |
| U | 399 | 5.0% |
| k | 399 | 5.0% |
| o | 399 | 5.0% |
| w | 399 | 5.0% |
| S | 333 | 4.2% |
| W | 236 | 3.0% |
race
Categorical
High correlation Imbalance
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 43.9 KiB |
| white | |
|---|---|
| asian | |
| other | 281 |
| black | 187 |
| native | 8 |
Length
| Max length | 6 |
|---|---|
| Median length | 5 |
| Mean length | 5.0014273 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | white |
|---|---|
| 2nd row | white |
| 3rd row | white |
| 4th row | white |
| 5th row | white |
Common Values
| Value | Count | Frequency (%) |
| white | 4194 | |
| asian | 935 | 16.7% |
| other | 281 | 5.0% |
| black | 187 | 3.3% |
| native | 8 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| white | 4194 | |
| asian | 935 | 16.7% |
| other | 281 | 5.0% |
| black | 187 | 3.3% |
| native | 8 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 5137 | |
| e | 4483 | |
| t | 4483 | |
| h | 4475 | |
| w | 4194 | |
| a | 2065 | |
| n | 943 | 3.4% |
| s | 935 | 3.3% |
| o | 281 | 1.0% |
| r | 281 | 1.0% |
| Other values (5) | 756 | 2.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 28033 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| i | 5137 | |
| e | 4483 | |
| t | 4483 | |
| h | 4475 | |
| w | 4194 | |
| a | 2065 | |
| n | 943 | 3.4% |
| s | 935 | 3.3% |
| o | 281 | 1.0% |
| r | 281 | 1.0% |
| Other values (5) | 756 | 2.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 28033 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| i | 5137 | |
| e | 4483 | |
| t | 4483 | |
| h | 4475 | |
| w | 4194 | |
| a | 2065 | |
| n | 943 | 3.4% |
| s | 935 | 3.3% |
| o | 281 | 1.0% |
| r | 281 | 1.0% |
| Other values (5) | 756 | 2.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 28033 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| i | 5137 | |
| e | 4483 | |
| t | 4483 | |
| h | 4475 | |
| w | 4194 | |
| a | 2065 | |
| n | 943 | 3.4% |
| s | 935 | 3.3% |
| o | 281 | 1.0% |
| r | 281 | 1.0% |
| Other values (5) | 756 | 2.7% |
ethnicity
Categorical
Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 43.9 KiB |
| nonhispanic | |
|---|---|
| hispanic | 249 |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 10.866726 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | nonhispanic |
|---|---|
| 2nd row | nonhispanic |
| 3rd row | nonhispanic |
| 4th row | nonhispanic |
| 5th row | nonhispanic |
Common Values
| Value | Count | Frequency (%) |
| nonhispanic | 5356 | |
| hispanic | 249 | 4.4% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| nonhispanic | 5356 | |
| hispanic | 249 | 4.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 16317 | |
| i | 11210 | |
| h | 5605 | 9.2% |
| s | 5605 | 9.2% |
| a | 5605 | 9.2% |
| p | 5605 | 9.2% |
| c | 5605 | 9.2% |
| o | 5356 | 8.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 60908 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| n | 16317 | |
| i | 11210 | |
| h | 5605 | 9.2% |
| s | 5605 | 9.2% |
| a | 5605 | 9.2% |
| p | 5605 | 9.2% |
| c | 5605 | 9.2% |
| o | 5356 | 8.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 60908 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| n | 16317 | |
| i | 11210 | |
| h | 5605 | 9.2% |
| s | 5605 | 9.2% |
| a | 5605 | 9.2% |
| p | 5605 | 9.2% |
| c | 5605 | 9.2% |
| o | 5356 | 8.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 60908 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| n | 16317 | |
| i | 11210 | |
| h | 5605 | 9.2% |
| s | 5605 | 9.2% |
| a | 5605 | 9.2% |
| p | 5605 | 9.2% |
| c | 5605 | 9.2% |
| o | 5356 | 8.8% |
gender
Categorical
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 43.9 KiB |
| M | |
|---|---|
| F |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | M |
|---|---|
| 2nd row | M |
| 3rd row | M |
| 4th row | M |
| 5th row | M |
Common Values
| Value | Count | Frequency (%) |
| M | 3702 | |
| F | 1903 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| m | 3702 | |
| f | 1903 |
Most occurring characters
| Value | Count | Frequency (%) |
| M | 3702 | |
| F | 1903 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 5605 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| M | 3702 | |
| F | 1903 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 5605 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| M | 3702 | |
| F | 1903 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 5605 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| M | 3702 | |
| F | 1903 |
income
Real number (ℝ)
High correlation
| Distinct | 99 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 95801.487 |
| Minimum | 7361 |
|---|---|
| Maximum | 816851 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 43.9 KiB |
Quantile statistics
| Minimum | 7361 |
|---|---|
| 5-th percentile | 26923 |
| Q1 | 58212 |
| median | 90297 |
| Q3 | 118047 |
| 95-th percentile | 179090 |
| Maximum | 816851 |
| Range | 809490 |
| Interquartile range (IQR) | 59835 |
Descriptive statistics
| Standard deviation | 91183.612 |
|---|---|
| Coefficient of variation (CV) | 0.95179746 |
| Kurtosis | 43.416419 |
| Mean | 95801.487 |
| Median Absolute Deviation (MAD) | 27750 |
| Skewness | 6.0009987 |
| Sum | 5.3696734 × 108 |
| Variance | 8.3144512 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 118047 | 1303 | |
| 92537 | 727 | |
| 35860 | 616 | |
| 82922 | 605 | |
| 90297 | 277 | 4.9% |
| 63727 | 220 | 3.9% |
| 30550 | 170 | 3.0% |
| 140772 | 131 | 2.3% |
| 72413 | 120 | 2.1% |
| 189277 | 101 | 1.8% |
| Other values (89) | 1335 |
| Value | Count | Frequency (%) |
| 7361 | 31 | |
| 7873 | 2 | < 0.1% |
| 8615 | 4 | 0.1% |
| 8752 | 10 | 0.2% |
| 10135 | 5 | 0.1% |
| 10682 | 24 | |
| 12128 | 14 | |
| 16969 | 20 | |
| 17382 | 30 | |
| 18258 | 5 | 0.1% |
| Value | Count | Frequency (%) |
| 816851 | 53 | |
| 762068 | 7 | 0.1% |
| 742063 | 10 | 0.2% |
| 550030 | 11 | 0.2% |
| 198522 | 12 | 0.2% |
| 198442 | 27 | 0.5% |
| 189277 | 101 | |
| 188023 | 8 | 0.1% |
| 179090 | 83 | |
| 178323 | 7 | 0.1% |
income_category
Categorical
High correlation
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 43.9 KiB |
| high-income | |
|---|---|
| low-income | |
| medium-income |
Length
| Max length | 13 |
|---|---|
| Median length | 11 |
| Mean length | 11.199286 |
| Min length | 10 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | high-income |
|---|---|
| 2nd row | high-income |
| 3rd row | medium-income |
| 4th row | high-income |
| 5th row | medium-income |
Common Values
| Value | Count | Frequency (%) |
| high-income | 3008 | |
| low-income | 1359 | |
| medium-income | 1238 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| high-income | 3008 | |
| low-income | 1359 | |
| medium-income | 1238 |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 9851 | |
| m | 8081 | |
| o | 6964 | |
| e | 6843 | |
| h | 6016 | |
| - | 5605 | |
| n | 5605 | |
| c | 5605 | |
| g | 3008 | 4.8% |
| l | 1359 | 2.2% |
| Other values (3) | 3835 | 6.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 62772 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| i | 9851 | |
| m | 8081 | |
| o | 6964 | |
| e | 6843 | |
| h | 6016 | |
| - | 5605 | |
| n | 5605 | |
| c | 5605 | |
| g | 3008 | 4.8% |
| l | 1359 | 2.2% |
| Other values (3) | 3835 | 6.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 62772 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| i | 9851 | |
| m | 8081 | |
| o | 6964 | |
| e | 6843 | |
| h | 6016 | |
| - | 5605 | |
| n | 5605 | |
| c | 5605 | |
| g | 3008 | 4.8% |
| l | 1359 | 2.2% |
| Other values (3) | 3835 | 6.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 62772 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| i | 9851 | |
| m | 8081 | |
| o | 6964 | |
| e | 6843 | |
| h | 6016 | |
| - | 5605 | |
| n | 5605 | |
| c | 5605 | |
| g | 3008 | 4.8% |
| l | 1359 | 2.2% |
| Other values (3) | 3835 | 6.1% |
age_of_patient
Real number (ℝ)
High correlation
| Distinct | 2204 |
|---|---|
| Distinct (%) | 39.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54.670392 |
| Minimum | 0.10136986 |
|---|---|
| Maximum | 110.04384 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 43.9 KiB |
Quantile statistics
| Minimum | 0.10136986 |
|---|---|
| 5-th percentile | 18.22137 |
| Q1 | 42.575342 |
| median | 58.454795 |
| Q3 | 64.939726 |
| 95-th percentile | 78.281096 |
| Maximum | 110.04384 |
| Range | 109.94247 |
| Interquartile range (IQR) | 22.364384 |
Descriptive statistics
| Standard deviation | 18.145749 |
|---|---|
| Coefficient of variation (CV) | 0.33191182 |
| Kurtosis | 0.71778371 |
| Mean | 54.670392 |
| Median Absolute Deviation (MAD) | 11.065753 |
| Skewness | -0.5743194 |
| Sum | 306427.55 |
| Variance | 329.26821 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 61.67671233 | 14 | 0.2% |
| 61.23561644 | 14 | 0.2% |
| 62.88493151 | 13 | 0.2% |
| 59.83561644 | 13 | 0.2% |
| 59.18356164 | 13 | 0.2% |
| 56.13424658 | 12 | 0.2% |
| 62.4630137 | 12 | 0.2% |
| 61.8109589 | 11 | 0.2% |
| 57.49589041 | 11 | 0.2% |
| 61.75342466 | 11 | 0.2% |
| Other values (2194) | 5481 |
| Value | Count | Frequency (%) |
| 0.101369863 | 2 | |
| 0.1150684932 | 1 | < 0.1% |
| 0.2465753425 | 2 | |
| 0.4602739726 | 1 | < 0.1% |
| 0.4931506849 | 2 | |
| 0.7397260274 | 4 | |
| 0.7534246575 | 1 | < 0.1% |
| 0.7780821918 | 2 | |
| 0.8520547945 | 1 | < 0.1% |
| 0.8849315068 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 110.0438356 | 1 | |
| 110.0054795 | 2 | |
| 108.9890411 | 2 | |
| 108.0109589 | 1 | |
| 107.9726027 | 2 | |
| 107.6931507 | 1 | |
| 107.339726 | 2 | |
| 107.309589 | 1 | |
| 106.9561644 | 2 | |
| 106.4164384 | 2 |
age_category
Categorical
High correlation
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 43.9 KiB |
| adult | |
|---|---|
| senior | |
| children | 252 |
Length
| Max length | 8 |
|---|---|
| Median length | 5 |
| Mean length | 5.3837645 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | adult |
|---|---|
| 2nd row | adult |
| 3rd row | adult |
| 4th row | adult |
| 5th row | adult |
Common Values
| Value | Count | Frequency (%) |
| adult | 3958 | |
| senior | 1395 | 24.9% |
| children | 252 | 4.5% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| adult | 3958 | |
| senior | 1395 | 24.9% |
| children | 252 | 4.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| d | 4210 | |
| l | 4210 | |
| a | 3958 | |
| u | 3958 | |
| t | 3958 | |
| e | 1647 | 5.5% |
| n | 1647 | 5.5% |
| i | 1647 | 5.5% |
| r | 1647 | 5.5% |
| s | 1395 | 4.6% |
| Other values (3) | 1899 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 30176 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| d | 4210 | |
| l | 4210 | |
| a | 3958 | |
| u | 3958 | |
| t | 3958 | |
| e | 1647 | 5.5% |
| n | 1647 | 5.5% |
| i | 1647 | 5.5% |
| r | 1647 | 5.5% |
| s | 1395 | 4.6% |
| Other values (3) | 1899 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 30176 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| d | 4210 | |
| l | 4210 | |
| a | 3958 | |
| u | 3958 | |
| t | 3958 | |
| e | 1647 | 5.5% |
| n | 1647 | 5.5% |
| i | 1647 | 5.5% |
| r | 1647 | 5.5% |
| s | 1395 | 4.6% |
| Other values (3) | 1899 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 30176 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| d | 4210 | |
| l | 4210 | |
| a | 3958 | |
| u | 3958 | |
| t | 3958 | |
| e | 1647 | 5.5% |
| n | 1647 | 5.5% |
| i | 1647 | 5.5% |
| r | 1647 | 5.5% |
| s | 1395 | 4.6% |
| Other values (3) | 1899 |
Interactions
Correlations
| age_category | age_of_patient | base_cost | code | ethnicity | gender | income | income_category | length_of_medication_in_days | marital | medicine_dispenses | payer_coverage | payer_id | race | reason_code_for_medication | reason_description_for_medication | total_cost_of_medicine | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| age_category | 1.000 | 0.919 | 0.000 | 0.632 | 0.115 | 0.105 | 0.218 | 0.260 | 0.000 | 0.565 | 0.134 | 0.000 | 0.441 | 0.304 | 0.477 | 0.477 | 0.000 |
| age_of_patient | 0.919 | 1.000 | -0.055 | -0.142 | 0.256 | 0.378 | 0.331 | 0.604 | 0.033 | 0.524 | -0.012 | 0.433 | 0.349 | 0.460 | 0.309 | 0.309 | -0.056 |
| base_cost | 0.000 | -0.055 | 1.000 | 0.079 | 0.072 | 0.021 | 0.186 | 0.005 | -0.095 | 0.018 | 0.169 | 0.430 | 0.015 | 0.000 | 0.000 | 0.000 | 0.925 |
| code | 0.632 | -0.142 | 0.079 | 1.000 | 0.450 | 0.553 | -0.092 | 0.510 | 0.143 | 0.514 | 0.110 | -0.093 | 0.362 | 0.473 | 0.764 | 0.764 | 0.073 |
| ethnicity | 0.115 | 0.256 | 0.072 | 0.450 | 1.000 | 0.118 | 0.254 | 0.154 | 0.037 | 0.188 | 0.059 | 0.072 | 0.346 | 0.136 | 0.233 | 0.233 | 0.059 |
| gender | 0.105 | 0.378 | 0.021 | 0.553 | 0.118 | 1.000 | 0.320 | 0.272 | 0.010 | 0.509 | 0.039 | 0.006 | 0.489 | 0.689 | 0.496 | 0.496 | 0.018 |
| income | 0.218 | 0.331 | 0.186 | -0.092 | 0.254 | 0.320 | 1.000 | 0.707 | -0.019 | 0.232 | 0.088 | 0.179 | 0.419 | 0.299 | 0.217 | 0.217 | 0.197 |
| income_category | 0.260 | 0.604 | 0.005 | 0.510 | 0.154 | 0.272 | 0.707 | 1.000 | 0.000 | 0.304 | 0.036 | 0.007 | 0.554 | 0.248 | 0.327 | 0.327 | 0.006 |
| length_of_medication_in_days | 0.000 | 0.033 | -0.095 | 0.143 | 0.037 | 0.010 | -0.019 | 0.000 | 1.000 | 0.000 | 0.551 | -0.129 | 0.055 | 0.006 | 0.378 | 0.378 | 0.051 |
| marital | 0.565 | 0.524 | 0.018 | 0.514 | 0.188 | 0.509 | 0.232 | 0.304 | 0.000 | 1.000 | 0.039 | 0.013 | 0.430 | 0.374 | 0.424 | 0.424 | 0.027 |
| medicine_dispenses | 0.134 | -0.012 | 0.169 | 0.110 | 0.059 | 0.039 | 0.088 | 0.036 | 0.551 | 0.039 | 1.000 | -0.004 | 0.095 | 0.064 | 0.235 | 0.235 | 0.477 |
| payer_coverage | 0.000 | 0.433 | 0.430 | -0.093 | 0.072 | 0.006 | 0.179 | 0.007 | -0.129 | 0.013 | -0.004 | 1.000 | 0.026 | 0.000 | 0.000 | 0.000 | 0.376 |
| payer_id | 0.441 | 0.349 | 0.015 | 0.362 | 0.346 | 0.489 | 0.419 | 0.554 | 0.055 | 0.430 | 0.095 | 0.026 | 1.000 | 0.288 | 0.235 | 0.235 | 0.019 |
| race | 0.304 | 0.460 | 0.000 | 0.473 | 0.136 | 0.689 | 0.299 | 0.248 | 0.006 | 0.374 | 0.064 | 0.000 | 0.288 | 1.000 | 0.390 | 0.390 | 0.000 |
| reason_code_for_medication | 0.477 | 0.309 | 0.000 | 0.764 | 0.233 | 0.496 | 0.217 | 0.327 | 0.378 | 0.424 | 0.235 | 0.000 | 0.235 | 0.390 | 1.000 | 1.000 | 0.000 |
| reason_description_for_medication | 0.477 | 0.309 | 0.000 | 0.764 | 0.233 | 0.496 | 0.217 | 0.327 | 0.378 | 0.424 | 0.235 | 0.000 | 0.235 | 0.390 | 1.000 | 1.000 | 0.000 |
| total_cost_of_medicine | 0.000 | -0.056 | 0.925 | 0.073 | 0.059 | 0.018 | 0.197 | 0.006 | 0.051 | 0.027 | 0.477 | 0.376 | 0.019 | 0.000 | 0.000 | 0.000 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
Sample
| start_time | stop_time | patient_id | payer_id | encounter_id | code | medicine_description | base_cost | payer_coverage | medicine_dispenses | total_cost_of_medicine | reason_code_for_medication | reason_description_for_medication | length_of_medication_in_days | medicine_ended_or_recovered | birthdate | marital | race | ethnicity | gender | income | income_category | age_of_patient | age_category | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2015-09-28 11:02:48 | 2015-10-15 09:04:48 | 30a6452c-4297-a1ac-977a-6a23237c7b46 | d31fccc3-1767-390d-966a-22a5156f4219 | 953c5138-ce17-4084-3432-1ac23f184528 | 857005 | Acetaminophen 325 MG / HYDROcodone Bitartrate 7.5 MG Oral Tablet | 2.51 | 0.00 | 1 | 2.51 | Unknown | Unknown | 0.043836 | 1 | 1994-02-06 | M | white | nonhispanic | M | 100511 | high-income | 21.654795 | adult |
| 1 | 2015-09-28 11:02:48 | 2015-10-31 11:02:48 | 30a6452c-4297-a1ac-977a-6a23237c7b46 | d31fccc3-1767-390d-966a-22a5156f4219 | 953c5138-ce17-4084-3432-1ac23f184528 | 310965 | Ibuprofen 200 MG Oral Tablet | 365.90 | 0.00 | 1 | 365.90 | Unknown | Unknown | 0.090411 | 1 | 1994-02-06 | M | white | nonhispanic | M | 100511 | high-income | 21.654795 | adult |
| 2 | 2005-11-08 20:24:07 | NaT | 34a4dcc4-35fb-6ad5-ab98-be285c586a4f | e03e23c9-4df1-3eb6-a62d-f70f02301496 | d1cea2e5-1735-089f-c72f-22ad16976663 | 310325 | ferrous sulfate 325 MG Oral Tablet | 0.15 | 0.00 | 50 | 7.50 | Unknown | Unknown | NaN | 1 | 1968-08-06 | D | white | nonhispanic | M | 49737 | medium-income | 37.282192 | adult |
| 3 | 2020-10-30 11:02:48 | 2020-11-20 11:02:48 | 30a6452c-4297-a1ac-977a-6a23237c7b46 | d31fccc3-1767-390d-966a-22a5156f4219 | 794baa15-fe5e-c061-e188-ad59022aeea5 | 313782 | Acetaminophen 325 MG Oral Tablet | 153.58 | 0.00 | 1 | 153.58 | Unknown | Unknown | 0.057534 | 1 | 1994-02-06 | M | white | nonhispanic | M | 100511 | high-income | 26.747945 | adult |
| 4 | 2008-08-27 00:53:03 | 2008-08-27 00:53:03 | 34a4dcc4-35fb-6ad5-ab98-be285c586a4f | 8fa6c185-e44e-3e34-8bd8-39be8694f4ce | 8a84efee-6fd7-f5b3-8816-9a1c60e720be | 1535362 | sodium fluoride 0.0272 MG/MG Oral Gel | 129.94 | 0.00 | 1 | 129.94 | 66383009.0 | Gingivitis (disorder) | 0.000000 | 1 | 1968-08-06 | D | white | nonhispanic | M | 49737 | medium-income | 40.084932 | adult |
| 5 | 2015-09-14 18:32:56 | 2015-10-29 18:47:19 | 7179458e-d6e3-c723-2530-d4acfe1c2668 | b046940f-1664-3047-bca7-dfa76be352a4 | ed8fc369-fd6a-5249-187c-690e5c4524ed | 313820 | Acetaminophen 160 MG Chewable Tablet | 45.86 | 0.00 | 1 | 45.86 | Unknown | Unknown | 0.123288 | 1 | 2008-12-21 | Unknown | white | nonhispanic | M | 133816 | high-income | 6.734247 | children |
| 6 | 2015-09-28 02:15:46 | 2015-09-28 02:15:46 | 7179458e-d6e3-c723-2530-d4acfe1c2668 | b046940f-1664-3047-bca7-dfa76be352a4 | d3540782-c36d-1535-4760-d2ede629e7f8 | 1535362 | sodium fluoride 0.0272 MG/MG Oral Gel | 129.94 | 0.00 | 1 | 129.94 | 81629009.0 | Traumatic dislocation of temporomandibular joint (disorder) | 0.000000 | 1 | 2008-12-21 | Unknown | white | nonhispanic | M | 133816 | high-income | 6.772603 | children |
| 7 | 2024-02-11 20:40:33 | 2024-02-11 20:40:33 | 7179458e-d6e3-c723-2530-d4acfe1c2668 | b046940f-1664-3047-bca7-dfa76be352a4 | d53a6541-f1cc-03a1-4888-84315485c98a | 1535362 | sodium fluoride 0.0272 MG/MG Oral Gel | 129.94 | 0.00 | 1 | 129.94 | 103697008.0 | Patient referral for dental care (procedure) | 0.000000 | 1 | 2008-12-21 | Unknown | white | nonhispanic | M | 133816 | high-income | 15.150685 | children |
| 8 | 2014-06-12 23:25:32 | 2015-06-07 23:25:32 | 37c177ea-4398-fb7a-29fa-70eb3d673876 | df166300-5a78-3502-a46a-832842197811 | c9a48d36-fbec-2907-6d7e-c3fcb6a5c0de | 751905 | Trinessa 28 Day Pack | 465.41 | 415.41 | 12 | 5584.92 | Unknown | Unknown | 0.986301 | 1 | 1994-01-27 | M | asian | nonhispanic | F | 17382 | low-income | 20.386301 | adult |
| 9 | 2014-11-21 23:25:32 | 2014-12-05 23:25:32 | 37c177ea-4398-fb7a-29fa-70eb3d673876 | df166300-5a78-3502-a46a-832842197811 | 22018eec-bde8-c567-abe0-cc2f6d4e1b8b | 1049221 | Acetaminophen 325 MG / Oxycodone Hydrochloride 5 MG Oral Tablet | 3.97 | 0.00 | 1 | 3.97 | Unknown | Unknown | 0.038356 | 1 | 1994-01-27 | M | asian | nonhispanic | F | 17382 | low-income | 20.830137 | adult |
| start_time | stop_time | patient_id | payer_id | encounter_id | code | medicine_description | base_cost | payer_coverage | medicine_dispenses | total_cost_of_medicine | reason_code_for_medication | reason_description_for_medication | length_of_medication_in_days | medicine_ended_or_recovered | birthdate | marital | race | ethnicity | gender | income | income_category | age_of_patient | age_category | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5595 | 2019-08-15 09:25:23 | 2020-08-20 09:25:23 | f339a5f7-0b09-3072-2b01-7c8e8ca2c1fc | a735bf55-83e9-331a-899d-a82a60b9f60c | 0a74b02f-ddd3-06f9-d8e3-adac74fc6ac5 | 308136 | amLODIPine 2.5 MG Oral Tablet | 0.91 | 0.00 | 4 | 3.64 | 59621000.0 | Essential hypertension (disorder) | 1.016438 | 1 | 1951-11-22 | S | asian | nonhispanic | F | 92537 | high-income | 67.775342 | senior |
| 5596 | 2020-08-20 09:25:23 | 2021-08-26 09:25:23 | f339a5f7-0b09-3072-2b01-7c8e8ca2c1fc | a735bf55-83e9-331a-899d-a82a60b9f60c | ce6ff2cc-9b44-3e32-02f6-ebe37611ff97 | 308136 | amLODIPine 2.5 MG Oral Tablet | 0.91 | 0.00 | 4 | 3.64 | 59621000.0 | Essential hypertension (disorder) | 1.016438 | 1 | 1951-11-22 | S | asian | nonhispanic | F | 92537 | high-income | 68.791781 | senior |
| 5597 | 2020-09-04 09:25:23 | 2020-10-04 09:25:23 | f339a5f7-0b09-3072-2b01-7c8e8ca2c1fc | a735bf55-83e9-331a-899d-a82a60b9f60c | 6875cd31-b2d3-6f84-00a2-97d3c3a45266 | 833135 | Milnacipran hydrochloride 100 MG Oral Tablet | 154.39 | 123.51 | 1 | 154.39 | 95417003.0 | Primary fibromyalgia syndrome (disorder) | 0.082192 | 1 | 1951-11-22 | S | asian | nonhispanic | F | 92537 | high-income | 68.832877 | senior |
| 5598 | 2021-05-09 07:25:23 | 2021-05-27 07:25:23 | f339a5f7-0b09-3072-2b01-7c8e8ca2c1fc | a735bf55-83e9-331a-899d-a82a60b9f60c | 9dd082e9-4cbe-6aa8-081c-df78e86b40da | 562251 | Amoxicillin 250 MG / Clavulanate 125 MG Oral Tablet | 45.86 | 36.69 | 1 | 45.86 | 444814009.0 | Viral sinusitis (disorder) | 0.049315 | 1 | 1951-11-22 | S | asian | nonhispanic | F | 92537 | high-income | 69.509589 | senior |
| 5599 | 2021-08-26 09:25:23 | 2022-09-01 09:25:23 | f339a5f7-0b09-3072-2b01-7c8e8ca2c1fc | a735bf55-83e9-331a-899d-a82a60b9f60c | ab2966ff-e387-2938-1bed-93fa0115250f | 308136 | amLODIPine 2.5 MG Oral Tablet | 1.37 | 1.10 | 4 | 5.48 | 59621000.0 | Essential hypertension (disorder) | 1.016438 | 1 | 1951-11-22 | S | asian | nonhispanic | F | 92537 | high-income | 69.808219 | senior |
| 5600 | 2022-09-01 09:25:23 | 2023-09-07 09:25:23 | f339a5f7-0b09-3072-2b01-7c8e8ca2c1fc | a735bf55-83e9-331a-899d-a82a60b9f60c | 5db88eb9-408d-acaa-779e-e81fd70e81ec | 308136 | amLODIPine 2.5 MG Oral Tablet | 0.91 | 0.73 | 4 | 3.64 | 59621000.0 | Essential hypertension (disorder) | 1.016438 | 1 | 1951-11-22 | S | asian | nonhispanic | F | 92537 | high-income | 70.824658 | senior |
| 5601 | 2022-09-15 14:31:04 | 2022-09-15 14:31:04 | f339a5f7-0b09-3072-2b01-7c8e8ca2c1fc | a735bf55-83e9-331a-899d-a82a60b9f60c | 94cc3e70-aa21-8b87-b0c5-f7d12dafdd7b | 1535362 | sodium fluoride 0.0272 MG/MG Oral Gel | 129.94 | 103.95 | 1 | 129.94 | 66383009.0 | Gingivitis (disorder) | 0.000000 | 1 | 1951-11-22 | S | asian | nonhispanic | F | 92537 | high-income | 70.863014 | senior |
| 5602 | 2023-09-07 09:25:23 | 2024-09-12 09:25:23 | f339a5f7-0b09-3072-2b01-7c8e8ca2c1fc | a735bf55-83e9-331a-899d-a82a60b9f60c | e3dfa401-6793-85f8-e430-bffb4d0aec1c | 308136 | amLODIPine 2.5 MG Oral Tablet | 1.37 | 0.00 | 4 | 5.48 | 59621000.0 | Essential hypertension (disorder) | 1.016438 | 1 | 1951-11-22 | S | asian | nonhispanic | F | 92537 | high-income | 71.841096 | senior |
| 5603 | 2024-04-14 09:25:23 | 2024-05-14 09:25:23 | f339a5f7-0b09-3072-2b01-7c8e8ca2c1fc | a735bf55-83e9-331a-899d-a82a60b9f60c | 03a0d6f1-5131-1f41-35bb-c965b63a3ebd | 596926 | duloxetine 20 MG Delayed Release Oral Capsule | 3.71 | 0.00 | 1 | 3.71 | 95417003.0 | Primary fibromyalgia syndrome (disorder) | 0.082192 | 1 | 1951-11-22 | S | asian | nonhispanic | F | 92537 | high-income | 72.443836 | senior |
| 5604 | 2024-09-12 09:25:23 | NaT | f339a5f7-0b09-3072-2b01-7c8e8ca2c1fc | a735bf55-83e9-331a-899d-a82a60b9f60c | 3f31f856-ac64-df94-45b2-9710c15536f8 | 308136 | amLODIPine 2.5 MG Oral Tablet | 0.91 | 0.00 | 1 | 0.91 | 59621000.0 | Essential hypertension (disorder) | NaN | 1 | 1951-11-22 | S | asian | nonhispanic | F | 92537 | high-income | 72.857534 | senior |